How to: Calculate Sales History Adjustment from Item Ledger Entries

The Calculation Rule using Item Ledger Entry helps you to create Sales History Adjustment for a specified location based on the Sales History entries for another location using predefined filters.

When items are sold through eCommerce, B2B commerce and so on, there are no physical stores present and the stocks are directly consumed from the warehouse. The sales from this channel are not included in the Average Usage calculation and therefore are not considered for replenishment.

With Replen. Sales History Adjustment Calculation Rules using Item Ledger Entries, the historical sales from this channel can be consolidated into a virtual location and Sales History Adjustment Entries will be created to simulate the sales. With this, these sales will also be taken into consideration when calculating the Average Usage for replenishment.

To calculate Sales History Adjustment from Item Ledger Entries

  1. Click the icon, enter Replen. Sales Hist. Adj., and select the relevant link.
  2. Click Calculate - Calculation Rules to open the Replen. Sales History Adjustment Calculation Rules page.
  3. Click New to create a new Replen. Sales History Adjustment Calculation Rule with Type Item Ledger Entries. Alternatively, open an existing one.
  4. Fill in the fields on the Filters and Item Ledger Entries FastTabs as described in the following table:

    5. Field Description
    Source Location Code This field specifies the source location to copy the Sales History entries from. This is a mandatory field to calculate the adjusted sales quantity using Rule Type Item Ledger Entries.
    Destination Location Code This field specifies the destination location to copy the Sales History entries to. This is a mandatory field to calculate the adjusted sales quantity using Rule Type Item Ledger Entries.
    Only Locations with Data Source Calculated (from Item Ledger Entries) can be used as Destination Location Code. For more information on setting up the Data Source for locations, see Setting Up a Location for Replenishment.
    Division Code Filter This field specifies the Division that will be used to filter the items.
    Item Category Code Filter This field specifies the Item Category that will be used to filter the items.
    Retail Product Filter This field specifies the Retail Product Group that will be used to filter the items.
    Item No. Filter This field specifies the item number that will be used to filter the items.
    Retail Customer Group Filter This field specifies the Retail Customer Group that will be used to filter the customers.
    Customer No. Filter This field specifies the customer number that will be used to filter the customers.
    Calculation Method This field specifies if the Replen. Sales History Adjustment Calculation Rule will run manually or using job scheduler.
    Last Run Date This field specifies the last system date when the Replen. Sales History Adjustment Calculation Rule was executed, either manually or using job scheduler.
    Last Calculated Date This field specifies the last WORKDATE when the Replen. Sales History Adjustment Calculation Rule was executed, either manually or using job scheduler.
    Note: Manually changing this field might cause existing Sales History Adjustment entries to be overwritten on the next calculation.

  5. Click Calculate. Alternatively, you can select the relevant Replen. Sales History Adjustment Calculation Rule and click the Calculate action on the Replen. Sales History Adjustment Calculation Rules page.

See Also

Sales History Adjustment Calculation Rules

Sales History Adjustment